
| venda | data_hora | cliente | mesa | item | produto | quantidade | valor_unit | desconto | total_item | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 460.0 | 01/02/2022 08:13 | CONSUMIDOR | M 1 | 119.0 | SUCO DE LARANJA 400ML | 1.0 | 14,5 | 0.0 | 14,5 |
| 1 | 460.0 | 01/02/2022 08:13 | CONSUMIDOR | M 1 | 121.0 | PAO SOURDOUGH OVOS | 1.0 | 15,5 | 0.0 | 15,5 |
| 2 | 461.0 | 01/02/2022 08:14 | CONSUMIDOR | M 2 | 119.0 | SUCO DE LARANJA 400ML | 1.0 | 14,5 | 0.0 | 14,5 |
| 3 | 461.0 | 01/02/2022 08:14 | CONSUMIDOR | M 2 | 121.0 | PAO SOURDOUGH OVOS | 1.0 | 15,5 | 0.0 | 15,5 |
| 4 | 465.0 | 01/02/2022 09:01 | CONSUMIDOR | M 1 | 46.0 | QUICHE BACON 90G | 2.0 | 19,5 | 0.0 | 39 |
<class 'pandas.core.frame.DataFrame'> RangeIndex: 25998 entries, 0 to 25997 Data columns (total 10 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 venda 25992 non-null float64 1 data_hora 25992 non-null object 2 cliente 25992 non-null object 3 mesa 22779 non-null object 4 item 25922 non-null float64 5 produto 25992 non-null object 6 quantidade 25992 non-null float64 7 valor_unit 25992 non-null object 8 desconto 25992 non-null float64 9 total_item 25992 non-null object dtypes: float64(4), object(6) memory usage: 2.0+ MB
venda 6 data_hora 6 cliente 6 mesa 3219 item 76 produto 6 quantidade 6 valor_unit 6 desconto 6 total_item 6 dtype: int64
| venda | data_hora | cliente | mesa | produto | quantidade | valor_unit | desconto | total_item | |
|---|---|---|---|---|---|---|---|---|---|
| 121 | 520.0 | 02/02/2022 16:57 | CONSUMIDOR | M0 | BOMBOLONI NUTELLA 80G | 2.0 | 12 | 0.0 | 24 |
| 122 | 520.0 | 02/02/2022 16:57 | CONSUMIDOR | M0 | TARTELETE DE MORANGO 120G | 1.0 | 18 | 0.0 | 18 |
| 123 | 520.0 | 02/02/2022 16:57 | CONSUMIDOR | M0 | CROISSANT MUSSATRELA DE | 1.0 | 25,5 | 0.0 | 25,5 |
| 894 | 856.0 | 11/02/2022 19:19 | CONSUMIDOR | M0 | CROISSANT BRIE PARMA MEL DE | 2.0 | 25,5 | 0.0 | 51 |
| 895 | 856.0 | 11/02/2022 19:19 | CONSUMIDOR | M0 | VH SANTA HORTENSIA SAUVIG | 1.0 | 59 | 0.0 | 59 |
| venda | data_hora | cliente | mesa | produto | quantidade | valor_unit | desconto | total_item | horario | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 460 | 2022-02-01 08:13:00 | CONSUMIDOR | M 1 | SUCO DE LARANJA 400ML | 1 | 14.5 | 0.0 | 14.5 | 2022-02-01 |
| 1 | 460 | 2022-02-01 08:13:00 | CONSUMIDOR | M 1 | PAO SOURDOUGH OVOS | 1 | 15.5 | 0.0 | 15.5 | 2022-02-01 |
| 2 | 461 | 2022-02-01 08:14:00 | CONSUMIDOR | M 2 | SUCO DE LARANJA 400ML | 1 | 14.5 | 0.0 | 14.5 | 2022-02-01 |
| 3 | 461 | 2022-02-01 08:14:00 | CONSUMIDOR | M 2 | PAO SOURDOUGH OVOS | 1 | 15.5 | 0.0 | 15.5 | 2022-02-01 |
| 4 | 465 | 2022-02-01 09:01:00 | CONSUMIDOR | M 1 | QUICHE BACON 90G | 2 | 19.5 | 0.0 | 39.0 | 2022-02-01 |
<class 'pandas.core.frame.DataFrame'> Int64Index: 25992 entries, 0 to 25997 Data columns (total 10 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 venda 25992 non-null int64 1 data_hora 25992 non-null datetime64[ns] 2 cliente 25992 non-null object 3 mesa 25992 non-null object 4 produto 25992 non-null object 5 quantidade 25992 non-null int64 6 valor_unit 25992 non-null float64 7 desconto 25992 non-null float64 8 total_item 25992 non-null float64 9 horario 25992 non-null object dtypes: datetime64[ns](1), float64(3), int64(2), object(4) memory usage: 2.2+ MB
'pt_BR.utf-8'
| venda | data_hora | cliente | mesa | produto | quantidade | valor_unit | desconto | total_item | horario | hora | minuto | hora_minuto | data | hora_do_dia | dia_da_semana | tipo_de_dia | item_count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 460 | 2022-02-01 08:13:00 | CONSUMIDOR | M 1 | SUCO DE LARANJA 400ML | 1 | 14.5 | 0.0 | 14.5 | 2022-02-01 | 8 | 13 | 08:13:00 | 2022-02-01 | manhã | terça | DDS | 1 |
| 1 | 460 | 2022-02-01 08:13:00 | CONSUMIDOR | M 1 | PAO SOURDOUGH OVOS | 1 | 15.5 | 0.0 | 15.5 | 2022-02-01 | 8 | 13 | 08:13:00 | 2022-02-01 | manhã | terça | DDS | 1 |
| 2 | 461 | 2022-02-01 08:14:00 | CONSUMIDOR | M 2 | SUCO DE LARANJA 400ML | 1 | 14.5 | 0.0 | 14.5 | 2022-02-01 | 8 | 14 | 08:14:00 | 2022-02-01 | manhã | terça | DDS | 1 |
| 3 | 461 | 2022-02-01 08:14:00 | CONSUMIDOR | M 2 | PAO SOURDOUGH OVOS | 1 | 15.5 | 0.0 | 15.5 | 2022-02-01 | 8 | 14 | 08:14:00 | 2022-02-01 | manhã | terça | DDS | 1 |
| 4 | 465 | 2022-02-01 09:01:00 | CONSUMIDOR | M 1 | QUICHE BACON 90G | 2 | 19.5 | 0.0 | 39.0 | 2022-02-01 | 9 | 1 | 09:01:00 | 2022-02-01 | manhã | terça | DDS | 1 |
total_item 53878.3 total_item_verif 22219.1 diference 31659.2 dtype: float64
| venda | data | produto | quantidade | valor_unit | total_item | total_item_verif | |
|---|---|---|---|---|---|---|---|
| 7039 | 3571 | 2022-04-29 | CROISSANT | 1 | 10.0 | 25.5 | 10.0 |
| 7047 | 3575 | 2022-04-29 | CROISSANT | 1 | 10.0 | 28.9 | 10.0 |
| 7054 | 3582 | 2022-04-29 | CROISSANT | 1 | 10.0 | 25.5 | 10.0 |
| 7072 | 3599 | 2022-04-30 | CROISSANT | 1 | 10.0 | 19.5 | 10.0 |
| 7074 | 3600 | 2022-04-30 | CROISSANT IFOOD | 1 | 12.0 | 51.0 | 12.0 |
/home/claudio/results/Dados_divergentes_vendas.html
/home/claudio/farina_in_natura001/CSV
Exploração dos Dados¶
CROISSANT 2393 PASTEL DE NATA 60G 1339 CROISSANT AMENDOAS 100G 742 FOLHADO MACA 80G 719 SANDUICHE DE PEPERONI BRIE 596 COOKIES 80G 559 CROISSANT IFOOD 534 SOURDOUGH AZEITONA E ALECRIM 517 FOLHADO FRANGO 160G 500 BOMBOLONI DOCE DE LEITE 80G 487 Name: produto, dtype: int64
| produto | quantidade | |
|---|---|---|
| 0 | CROISSANT | 2393 |
| 1 | PASTEL DE NATA 60G | 1339 |
| 2 | CROISSANT AMENDOAS 100G | 742 |
| 3 | FOLHADO MACA 80G | 719 |
| 4 | SANDUICHE DE PEPERONI BRIE | 596 |
CROISSANT 0.092067 PASTEL DE NATA 60G 0.051516 CROISSANT AMENDOAS 100G 0.028547 FOLHADO MACA 80G 0.027662 SANDUICHE DE PEPERONI BRIE 0.022930 COOKIES 80G 0.021507 CROISSANT IFOOD 0.020545 SOURDOUGH AZEITONA E ALECRIM 0.019891 FOLHADO FRANGO 160G 0.019237 BOMBOLONI DOCE DE LEITE 80G 0.018737 Name: produto, dtype: float64
| produto | proporção | |
|---|---|---|
| 0 | CROISSANT | 0.092067 |
| 1 | PASTEL DE NATA 60G | 0.051516 |
| 2 | CROISSANT AMENDOAS 100G | 0.028547 |
| 3 | FOLHADO MACA 80G | 0.027662 |
| 4 | SANDUICHE DE PEPERONI BRIE | 0.022930 |
<class 'pandas.core.frame.DataFrame'> RangeIndex: 212 entries, 0 to 211 Data columns (total 2 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 produto 212 non-null object 1 proporção 212 non-null float64 dtypes: float64(1), object(1) memory usage: 3.4+ KB
O número de diferentes itens vendido pela loja é: 212
A média de itens por venda é: 2.79 itens
O número médio de itens vendidos por período do dia é: hora_do_dia manhã 3.046419 noite 2.663510 tarde 2.783376 Name: item_count, dtype: float64
/tmp/ipykernel_2908/1953160630.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
| horario | item_count | |
|---|---|---|
| 0 | 2022-02-01 | 74 |
| 1 | 2022-02-02 | 88 |
| 2 | 2022-02-03 | 81 |
| 3 | 2022-02-04 | 110 |
| 4 | 2022-02-05 | 112 |
| hora | item_count | |
|---|---|---|
| 0 | 7 | 8 |
| 1 | 9 | 5 |
| 2 | 10 | 5 |
| 3 | 11 | 7 |
| 4 | 12 | 4 |
| 5 | 13 | 8 |
| 6 | 14 | 5 |
| 7 | 15 | 3 |
| 8 | 16 | 2254 |
| 9 | 17 | 3 |
| 10 | 18 | 1 |
| horario | item_count | |
|---|---|---|
| 0 | 2022-02-01 | 74 |
| 1 | 2022-02-02 | 88 |
| 2 | 2022-02-03 | 81 |
| 3 | 2022-02-04 | 110 |
| 4 | 2022-02-07 | 61 |
| horario | item_count | |
|---|---|---|
| 0 | 2022-02-05 | 112 |
| 1 | 2022-02-06 | 121 |
| 2 | 2022-02-12 | 108 |
| 3 | 2022-02-13 | 186 |
| 4 | 2022-02-19 | 107 |
O menor número de vendas em um dia de semana foi: 1 O maior número de vendas em um dia de semana foi: 241 O número médio de vendas em um dia de semana é: 75.81005586592178
O menor número de vendas em um dia de fim-de-semana foi: 65 O maior número de vendas em um dia fim-de-semana foi: 227 O número médio de vendas em um dia fim-de-semana é: 133.73611111111111
O número médio de itens em cada venda por tipo de dia é: tipo_de_dia DDS 2.650391 FDS 2.836230 Name: item_count, dtype: float64
| horario | tipo_de_dia | item_count | |
|---|---|---|---|
| 0 | 2022-02-01 | DDS | 74 |
| 1 | 2022-02-02 | DDS | 88 |
| 2 | 2022-02-03 | DDS | 81 |
| 3 | 2022-02-04 | DDS | 110 |
| 4 | 2022-02-05 | FDS | 112 |
<class 'pandas.core.frame.DataFrame'> RangeIndex: 179 entries, 0 to 178 Data columns (total 2 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 horario 179 non-null object 1 total_item 179 non-null float64 dtypes: float64(1), object(1) memory usage: 2.9+ KB
| horario | item_count | |
|---|---|---|
| 0 | 2022-02-01 | 74 |
| 1 | 2022-02-02 | 88 |
| 2 | 2022-02-03 | 81 |
| 3 | 2022-02-04 | 110 |
| 4 | 2022-02-05 | 112 |
| dia_da_semana | horario | item_count | |
|---|---|---|---|
| 0 | domingo | 2022-02-06 | 121 |
| 1 | domingo | 2022-02-13 | 186 |
| 2 | domingo | 2022-02-20 | 156 |
| 3 | domingo | 2022-02-27 | 86 |
| 4 | domingo | 2022-03-06 | 126 |
| 5 | domingo | 2022-03-13 | 145 |
| 6 | domingo | 2022-03-20 | 140 |
| 7 | domingo | 2022-03-27 | 121 |
| 8 | domingo | 2022-04-03 | 93 |
| 9 | domingo | 2022-04-10 | 77 |
'/home/claudio/results/grafico13 - Vendas_agregadas_itens_dias_semana_PX.html'
expr: syntax error: missing argument after ‘8’
/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001 /usr/share/atom/atom: bad option: --pid=7358
'/home/claudio/results/grafico016B - percentual_vendas_hora_dia.html'
/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001 /usr/share/atom/atom: bad option: --pid=7505
expr: syntax error: missing argument after ‘8’
| dia_da_semana | hora_do_dia | item_count | |
|---|---|---|---|
| 0 | segunda | manhã | 587 |
| 1 | segunda | noite | 1354 |
| 2 | segunda | tarde | 548 |
| 3 | terça | manhã | 545 |
| 4 | terça | noite | 1359 |
| 5 | terça | tarde | 619 |
| 6 | quarta | manhã | 642 |
| 7 | quarta | noite | 1403 |
| 8 | quarta | tarde | 811 |
| 9 | quinta | manhã | 526 |
| 10 | quinta | noite | 1459 |
| 11 | quinta | tarde | 729 |
| 12 | sexta | manhã | 744 |
| 13 | sexta | noite | 1575 |
| 14 | sexta | tarde | 669 |
| 15 | sábado | manhã | 1512 |
| 16 | sábado | noite | 2096 |
| 17 | sábado | tarde | 986 |
| 18 | domingo | manhã | 2310 |
| 19 | domingo | noite | 1793 |
| 20 | domingo | tarde | 932 |
0 587 3 545 6 642 9 526 12 744 15 1512 18 2310 Name: item_count, dtype: int64
| item_count | |
|---|---|
| hora | |
| 6 | 41 |
| 7 | 524 |
| 8 | 1289 |
| 9 | 1749 |
| 10 | 1817 |
| 11 | 1446 |
| 12 | 737 |
| 13 | 627 |
| 14 | 769 |
| 15 | 1249 |
| 16 | 1912 |
| 17 | 3279 |
| 18 | 2917 |
| 19 | 2416 |
| 20 | 2094 |
| 21 | 333 |
Rule: ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA Support: 0.0061068702290076335 Confidence: 0.5416666666666666 Lift: 70.95833333333333 ===================================== Rule: CROISSANT -> ADICIONAL DE MUSSARELA Support: 0.009395184967704051 Confidence: 0.8333333333333333 Lift: 4.038607474862455 ===================================== Rule: CROISSANT -> ADICIONAL DE PRESUNTO Support: 0.006928948913681738 Confidence: 0.9076923076923077 Lift: 4.398975526465566 ===================================== Rule: AGUA MINERAL S/GAS 500ML -> CROISSANT Support: 0.01996476805637111 Confidence: 0.4197530864197531 Lift: 2.0342615428936814 ===================================== Rule: PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS AVEIA Support: 0.007868467410452143 Confidence: 0.24814814814814815 Lift: 9.107678799489145 ===================================== Rule: CROISSANT -> CAFE CATUAI VERMELHO C/LEITE G Support: 0.007868467410452143 Confidence: 0.43506493506493504 Lift: 2.1084677985645546 ===================================== Rule: CROISSANT -> CAFE CATUAI VERMELHO G 200ML Support: 0.013740458015267175 Confidence: 0.46799999999999997 Lift: 2.2680819578827545 ===================================== Rule: CROISSANT -> CAFE COLMEIA C/ LEITE G 200ML Support: 0.00551967116852613 Confidence: 0.5280898876404494 Lift: 2.5592973211487915 ===================================== Rule: CROISSANT -> CAFE COLMEIA G 200ML Support: 0.007633587786259542 Confidence: 0.4276315789473684 Lift: 2.0724433094688917 ===================================== Rule: CROISSANT -> LARANJA 400 ML Support: 0.021374045801526718 Confidence: 0.6275862068965518 Lift: 3.041489215551587 ===================================== Rule: SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA MEL DE Support: 0.005989430416911333 Confidence: 0.2451923076923077 Lift: 5.394864341085272 ===================================== Rule: CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD Support: 0.005167351732237228 Confidence: 0.4356435643564356 Lift: 9.391151773405188 ===================================== Rule: MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT PAIN DE CHOC Support: 0.00540223135642983 Confidence: 0.2358974358974359 Lift: 5.046901172529314 ===================================== Rule: CROISSANT -> ADICIONAL DE PRESUNTO Support: 0.005637110980622431 Confidence: 0.5 Lift: 72.16101694915254 =====================================
| Rule | Support | Confidence | Lift | |
|---|---|---|---|---|
| 0 | ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA | 0.0061068702290076335 | 0.5416666666666666 | 70.95833333333333 |
| 1 | CROISSANT -> ADICIONAL DE MUSSARELA | 0.009395184967704051 | 0.8333333333333333 | 4.038607474862455 |
| 2 | CROISSANT -> ADICIONAL DE PRESUNTO | 0.006928948913681738 | 0.9076923076923077 | 4.398975526465566 |
| 3 | AGUA MINERAL S/GAS 500ML -> CROISSANT | 0.01996476805637111 | 0.4197530864197531 | 2.0342615428936814 |
| 4 | PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS A... | 0.007868467410452143 | 0.24814814814814815 | 9.107678799489145 |
| 5 | CROISSANT -> CAFE CATUAI VERMELHO C/LEITE G | 0.007868467410452143 | 0.43506493506493504 | 2.1084677985645546 |
| 6 | CROISSANT -> CAFE CATUAI VERMELHO G 200ML | 0.013740458015267175 | 0.46799999999999997 | 2.2680819578827545 |
| 7 | CROISSANT -> CAFE COLMEIA C/ LEITE G 200ML | 0.00551967116852613 | 0.5280898876404494 | 2.5592973211487915 |
| 8 | CROISSANT -> CAFE COLMEIA G 200ML | 0.007633587786259542 | 0.4276315789473684 | 2.0724433094688917 |
| 9 | CROISSANT -> LARANJA 400 ML | 0.021374045801526718 | 0.6275862068965518 | 3.041489215551587 |
| 10 | SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA ... | 0.005989430416911333 | 0.2451923076923077 | 5.394864341085272 |
| 11 | CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD | 0.005167351732237228 | 0.4356435643564356 | 9.391151773405188 |
| 12 | MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT P... | 0.00540223135642983 | 0.2358974358974359 | 5.046901172529314 |
| 13 | CROISSANT -> ADICIONAL DE PRESUNTO | 0.005637110980622431 | 0.5 | 72.16101694915254 |
'/home/claudio/results/grafico19 - Aplicando_Apriori_Modelo_01.html'
expr: syntax error: missing argument after ‘8’
/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001 /usr/share/atom/atom: bad option: --pid=7649
Rule: ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA Support: 0.009764758100310697 Confidence: 0.5945945945945946 Lift: 40.5945945945946 ===================================== Rule: AGUA MINERAL S/GAS 500ML -> ADICIONAL DE MUSSARELA Support: 0.005326231691078562 Confidence: 0.3243243243243244 Lift: 5.294947121034079 ===================================== Rule: CROISSANT -> ADICIONAL DE MUSSARELA Support: 0.015090989791389259 Confidence: 0.918918918918919 Lift: 3.344627341396324 ===================================== Rule: CROISSANT -> ADICIONAL DE PRESUNTO Support: 0.013315579227696404 Confidence: 0.9090909090909091 Lift: 3.3088559259803203 ===================================== Rule: CROISSANT BRIE PARMA MEL DE -> AGUA MINERAL SEM GAS 500 ML Support: 0.007545494895694629 Confidence: 0.2 Lift: 5.006666666666667 ===================================== Rule: PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS AVEIA Support: 0.024411895250776743 Confidence: 0.2972972972972973 Lift: 3.9170222854433385 ===================================== Rule: BOWL DE IOGURTE FRUTAS AVEIA -> SELECAO DE PAES GELEIA Support: 0.010208610741233911 Confidence: 0.2674418604651163 Lift: 3.2570081709616594 ===================================== Rule: LARANJA 400 ML -> CAFE CATUAI VERMELHO C/LEITE G Support: 0.007989347536617843 Confidence: 0.23684210526315788 Lift: 3.629967776584318 ===================================== Rule: COOKIES 80G IFOOD -> CROISSANT IFOOD Support: 0.005770084332001775 Confidence: 0.619047619047619 Lift: 7.621389539422324 ===================================== Rule: CROISSANT OVOS BACON MEL -> CROISSANT BRIE PARMA MEL DE Support: 0.007989347536617843 Confidence: 0.2 Lift: 4.506 ===================================== Rule: SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA MEL DE Support: 0.00887705281846427 Confidence: 0.22222222222222224 Lift: 6.032128514056224 ===================================== Rule: CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD Support: 0.008433200177541057 Confidence: 0.5428571428571428 Lift: 6.683372365339578 ===================================== Rule: SOURDOUGH 369G IFOOD -> CROISSANT IFOOD Support: 0.008433200177541057 Confidence: 0.59375 Lift: 7.309938524590163 ===================================== Rule: SUCO DE LARANJA 400ML -> CROISSANT MUSSATRELA DE Support: 0.006657789613848202 Confidence: 0.2459016393442623 Lift: 6.674896306537625 ===================================== Rule: CROISSANT OVOS BACON MEL -> SUCO DE LARANJA 400ML Support: 0.008433200177541057 Confidence: 0.2289156626506024 Lift: 5.157469879518072 ===================================== Rule: MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT PAIN DE CHOC Support: 0.007101642254771416 Confidence: 0.2857142857142857 Lift: 5.646616541353383 ===================================== Rule: CROISSANT -> ADICIONAL DE PRESUNTO Support: 0.009320905459387484 Confidence: 0.5675675675675677 Lift: 42.624324324324334 ===================================== Rule: AGUA MINERAL S/GAS 500ML -> CROISSANT Support: 0.006657789613848202 Confidence: 0.2054794520547945 Lift: 3.354675402025015 ===================================== Rule: CROISSANT -> BOWL DE IOGURTE FRUTAS AVEIA Support: 0.006213936972924989 Confidence: 0.29166666666666663 Lift: 4.470238095238095 ===================================== Rule: CROISSANT -> LARANJA 400 ML Support: 0.006657789613848202 Confidence: 0.2054794520547945 Lift: 3.149287112105116 ===================================== Rule: PAO SOURDOUGH OVOS -> CROISSANT Support: 0.005326231691078562 Confidence: 0.3076923076923077 Lift: 5.590570719602978 ===================================== Rule: PAO SOURDOUGH OVOS -> CROISSANT Support: 0.005326231691078562 Confidence: 0.3076923076923077 Lift: 4.71585557299843 ===================================== Rule: CROISSANT -> SANDUICHE DE PEPERONI BRIE Support: 0.006213936972924989 Confidence: 0.3783783783783784 Lift: 3.1928332827209234 =====================================
| Rule | Support | Confidence | Lift | |
|---|---|---|---|---|
| 5 | PAO SOURDOUGH OVOS -> BOWL DE IOGURTE FRUTAS A... | 0.024411895250776743 | 0.2972972972972973 | 3.9170222854433385 |
| 2 | CROISSANT -> ADICIONAL DE MUSSARELA | 0.015090989791389259 | 0.918918918918919 | 3.344627341396324 |
| 3 | CROISSANT -> ADICIONAL DE PRESUNTO | 0.013315579227696404 | 0.9090909090909091 | 3.3088559259803203 |
| 6 | BOWL DE IOGURTE FRUTAS AVEIA -> SELECAO DE PAE... | 0.010208610741233911 | 0.2674418604651163 | 3.2570081709616594 |
| 0 | ADICIONAL DE PRESUNTO -> ADICIONAL DE MUSSARELA | 0.009764758100310697 | 0.5945945945945946 | 40.5945945945946 |
| 16 | CROISSANT -> ADICIONAL DE PRESUNTO | 0.009320905459387484 | 0.5675675675675677 | 42.624324324324334 |
| 10 | SUCO DE LARANJA 400ML -> CROISSANT BRIE PARMA ... | 0.00887705281846427 | 0.22222222222222224 | 6.032128514056224 |
| 14 | CROISSANT OVOS BACON MEL -> SUCO DE LARANJA 400ML | 0.008433200177541057 | 0.2289156626506024 | 5.157469879518072 |
| 12 | SOURDOUGH 369G IFOOD -> CROISSANT IFOOD | 0.008433200177541057 | 0.59375 | 7.309938524590163 |
| 11 | CROISSANT IFOOD -> PASTEL DE NATA 60G IFOOD | 0.008433200177541057 | 0.5428571428571428 | 6.683372365339578 |
| 9 | CROISSANT OVOS BACON MEL -> CROISSANT BRIE PAR... | 0.007989347536617843 | 0.2 | 4.506 |
| 7 | LARANJA 400 ML -> CAFE CATUAI VERMELHO C/LEITE G | 0.007989347536617843 | 0.23684210526315788 | 3.629967776584318 |
| 4 | CROISSANT BRIE PARMA MEL DE -> AGUA MINERAL SE... | 0.007545494895694629 | 0.2 | 5.006666666666667 |
| 15 | MINI CROISSANT 25G KIT C 5 -> MINI CROISSANT P... | 0.007101642254771416 | 0.2857142857142857 | 5.646616541353383 |
| 13 | SUCO DE LARANJA 400ML -> CROISSANT MUSSATRELA DE | 0.006657789613848202 | 0.2459016393442623 | 6.674896306537625 |
| 17 | AGUA MINERAL S/GAS 500ML -> CROISSANT | 0.006657789613848202 | 0.2054794520547945 | 3.354675402025015 |
| 19 | CROISSANT -> LARANJA 400 ML | 0.006657789613848202 | 0.2054794520547945 | 3.149287112105116 |
| 18 | CROISSANT -> BOWL DE IOGURTE FRUTAS AVEIA | 0.006213936972924989 | 0.29166666666666663 | 4.470238095238095 |
| 22 | CROISSANT -> SANDUICHE DE PEPERONI BRIE | 0.006213936972924989 | 0.3783783783783784 | 3.1928332827209234 |
| 8 | COOKIES 80G IFOOD -> CROISSANT IFOOD | 0.005770084332001775 | 0.619047619047619 | 7.621389539422324 |
| 1 | AGUA MINERAL S/GAS 500ML -> ADICIONAL DE MUSSA... | 0.005326231691078562 | 0.3243243243243244 | 5.294947121034079 |
| 20 | PAO SOURDOUGH OVOS -> CROISSANT | 0.005326231691078562 | 0.3076923076923077 | 5.590570719602978 |
| 21 | PAO SOURDOUGH OVOS -> CROISSANT | 0.005326231691078562 | 0.3076923076923077 | 4.71585557299843 |
<class 'pandas.core.frame.DataFrame'> RangeIndex: 60 entries, 0 to 59 Data columns (total 9 columns): # Column Non-Null Count Dtype --- ------ -------------- ----- 0 antecedents 60 non-null string 1 consequents 60 non-null string 2 antecedent support 60 non-null float64 3 consequent support 60 non-null float64 4 support 60 non-null float64 5 confidence 60 non-null float64 6 lift 60 non-null float64 7 leverage 60 non-null float64 8 conviction 60 non-null float64 dtypes: float64(7), string(2) memory usage: 4.3 KB
| antecedents | consequents | antecedent support | consequent support | support | confidence | lift | leverage | conviction | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | CROISSANT, ADICIONAL DE MUSSARELA | ADICIONAL DE PRESUNTO | 0.009395 | 0.007634 | 0.005637 | 0.600000 | 78.600000 | 0.005565 | 2.480916 |
| 1 | CROISSANT, ADICIONAL DE PRESUNTO | ADICIONAL DE MUSSARELA | 0.006929 | 0.011274 | 0.005637 | 0.813559 | 72.161017 | 0.005559 | 5.303166 |
| 2 | ADICIONAL DE PRESUNTO | ADICIONAL DE MUSSARELA | 0.007634 | 0.011274 | 0.006107 | 0.800000 | 70.958333 | 0.006021 | 4.943629 |
| 3 | CROISSANT IFOOD | PASTEL DE NATA 60G IFOOD | 0.046389 | 0.011861 | 0.005167 | 0.111392 | 9.391152 | 0.004617 | 1.112008 |
| 4 | PAO SOURDOUGH OVOS | BOWL DE IOGURTE FRUTAS AVEIA | 0.027246 | 0.031709 | 0.007868 | 0.288793 | 9.107679 | 0.007005 | 1.361476 |
'/home/claudio/results/grafico20 - Apriori_Method_02_all_Day.html'
/usr/share/atom/atom: bad option: --executed-from=/home/claudio/farina_in_natura001 /usr/share/atom/atom: bad option: --pid=7796
expr: syntax error: missing argument after ‘8’
antecedents (CROISSANT, ADICIONAL DE MUSSARELA) 132.319444 (CROISSANT, ADICIONAL DE PRESUNTO) 123.727273 (ADICIONAL DE PRESUNTO) 123.727273 (CROISSANT) 29.852497 (BOMBOLONI DOCE DE LEITE 80G) 13.857519 (CROISSANT IFOOD) 13.610000 (BOMBOLONI NUTELLA 80G, PASTEL DE NATA 60G) 11.864259 (FOLHADO FRANGO 160G, PASTEL DE NATA 60G) 10.807043 (FOLHADO FRANGO 160G) 10.014217 (CROISSANT TRADICIONAL 80 G) 9.120090 (MINI CROISSANT 25G KIT C 5) 7.845827 (CAFE INTENSO CAPSULA P 50ML) 7.815052 (BOMBOLONI NUTELLA 80G) 6.464520 (CROISSANT AMENDOAS 100G) 5.951058 (SOURDOUGH 369G) 5.620532 (FOCACCIA FORMAGGIO 246G) 5.281658 (AGUA MINERAL S/GAS 500ML) 4.844972 (FOLHADO FRANGO 160G, BOMBOLONI NUTELLA 80G) 4.472770 (TORRADA FARINA 165G) 4.391127 (QUICHE DE TOMATE SECO SALADA) 4.124911 (CAFE EQUILIBRADO CAPSULA P) 3.764748 (FOLHADO MACA 80G) 3.569901 (SANDUICHE DE PEPERONI BRIE) 3.489744 (CROISSANT, PASTEL DE NATA 60G) 3.434391 (PASTEL DE NATA 60G) 2.713261 (CAFE EQUILIBRADO CAPSULA G) 2.396127 (FOLHADO FRANGO 160G, CROISSANT) 2.354089 (CROISANT DE CROISSANT QUEIJO) 2.236385 (PIZZA AL TAGLIO GORGONZOLA E) 2.223856 (MINI CROISSANT 25G) 1.825620 (SOURDOUGH SEMI INTEGRAL 370G) 1.779085 (QUICHE DE BACON SALADA VERDE) 1.442829 (QUICHE DE FRANGO ALHO PORO) 1.378164 (MINI CROISSANT PAIN DE CHOC) 1.369215 (MINI PAIN AU CHOCOLAT 35G) 1.277934 (SOURDOUGH AZEITONA E ALECRIM) 1.250919 Name: lift, dtype: float64